package com.budwk.app.sqfw.enums.datamange;

import cn.hutool.core.util.ObjectUtil;
import com.budwk.app.common.config.AppException;
import com.budwk.app.sqfw.constants.CommonForAdminConstants;
import com.budwk.app.sqfw.enums.FileMergingBeanNameEnum;
import com.budwk.app.util.adminUtils.CommonCheckUtils;
import lombok.Getter;
import org.apache.commons.lang3.StringUtils;
import org.nutz.dao.util.cri.Static;

import java.util.Arrays;
import java.util.Collections;
import java.util.List;
import java.util.Optional;

@Getter
public enum DataManageHiddenDangersEnum {

    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_1("安全排查整治", "消防", "isHydrantOperational", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_2("安全排查整治", "消防", "isAbleToUseFireExtinguisher", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_3("安全排查整治", "消防", "isExposedWiringGasLines", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_4("安全排查整治", "消防", "useHighPowerAppliances", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_5("安全排查整治", "消防", "blockedSafetyExits", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_6("安全排查整治", "消防", "obstructingDoorsAndWindows", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_7("安全排查整治", "消防", "productionAndAccommodationAreIntegrated", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_8("安全排查整治", "消防", "indoorParkingBicycles", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_9("安全排查整治", "消防", "isConstructingFloors", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_10("安全排查整治", "消防", "whetherElecCircuitIs", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_11("安全排查整治", "消防", "safetyExitsAreStackedWithDebris", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_12("安全排查整治", "消防", "isConstructingFloors", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_13("安全排查整治", "消防", "whetherElecCircuitIs", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_15("安全排查整治", "消防", "fireSafetyManagementResponsibilities", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_16("安全排查整治", "消防", "whetherElectricParked", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_17("安全排查整治", "消防", "whetherSafetyStaff", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_18("安全排查整治", "消防", "isHydrantBlocked", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_19("安全排查整治", "消防", "isThereAnyBlockage", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_20("安全排查整治", "消防", "accomExitsCovered", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_21("安全排查整治", "消防", "passTheFireSafetyInspection", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_22("安全排查整治", "消防", "fireProtectionZonesAreUpToStandard", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_23("安全排查整治", "消防", "whetherToEstablishVariousSafetyProductionSystems", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_24("安全排查整治", "消防", "isFireproofWells", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_25("安全排查整治", "消防", "runningStatusOfFireFightingEquipment", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_26("安全排查整治", "消防", "whetherThereAreMoreThanTwoCertifiedDutyOfficers", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_27("安全排查整治", "消防", "isExtinguisher", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_28("安全排查整治", "消防", "hasEstablishedSafetyWorkPlanAndTrainingPlan", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_29("安全排查整治", "消防", "isEstabedSafeResSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_30("安全排查整治", "消防", "isSafetyProductionSupervisorStaffed", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_31("安全排查整治", "消防", "isWarningSignInstalled", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_32("安全排查整治", "消防", "placeFireExtinguishersNumber", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_33("安全排查整治", "消防", "isExtinguisherExpiredOrDamaged", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_34("安全排查整治", "消防", "isOverloadedSocketInUse", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_35("安全排查整治", "消防", "isElevatorInspectionMaintenanceDone", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_36("安全排查整治", "消防", "isSmokeAlarmSystemOperational", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_37("安全排查整治", "消防", "areEmergencyLightsExitLightsIntact", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_38("安全排查整治", "消防", "stackingDebrisRoutes", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_39("安全排查整治", "消防", "isBlockingFireTruckAccess", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_40("安全排查整治", "消防", "isFireSafetyPatrolDataComplete", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_41("安全排查整治", "消防", "masterEmergencyHandlingMeasures", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_42("安全排查整治", "消防", "isBuildingSettlementCracking", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_43("安全排查整治", "消防", "isUnauthorizedElectricGasConnection", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_44("安全排查整治", "消防", "areObstaclesDoorsFfire", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_45("安全排查整治", "消防", "isIndoorChargingElectricVehicle", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_46("安全排查整治", "消防", "hasSafetyProtectionFacility", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_47("安全排查整治", "消防", "isSafetyProtectionFacilityAtRisk", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_48("安全排查整治", "消防", "areFacilitiesInCompliance", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_49("安全排查整治", "消防", "isThereAnyBlockage", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_50("安全排查整治", "消防", "blockageOfFireEscape", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_51("安全排查整治", "消防", "isSiteConstructionIllegallyDirected", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_52("安全排查整治", "消防", "isIllegalOperation", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_53("安全排查整治", "消防", "hasViolatedLaborDiscipline", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_54("安全排查整治", "消防", "hasEstablishedDailyInspectionRecord", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_55("安全排查整治", "消防", "hasEstablishedSpaceInspectionRecord", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_56("安全排查整治", "消防", "isLimitedSpaceSafetyTrainingImplemented", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_57("安全排查整治", "消防", "hasEstablishedConfinedSpaceSafetyProductionPlan", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_58("安全排查整治", "消防", "isOperatingAccordingToConfinedSpaceApprovalSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_59("安全排查整治", "消防", "isOperatingAccordingToStandardProcedure", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_60("安全排查整治", "消防", "enterpriseSecurityTraining", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_61("安全排查整治", "消防", "enterpriseAccidentProblem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_62("安全排查整治", "消防", "enterpriseSecuritySkills", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_63("安全排查整治", "消防", "enterpriseInspection", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_64("安全排查整治", "消防", "enterpriseLaborDispatch", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_65("安全排查整治", "消防", "workWithoutALicense", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_66("安全排查整治", "消防", "buildRescueTeam", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_67("安全排查整治", "消防", "makeEmergencyPlans", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_68("安全排查整治", "消防", "makeTrainingPlan", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_69("安全排查整治", "消防", "formulateFinancialInput", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_70("安全排查整治", "消防", "hiddenDangerControlSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_71("安全排查整治", "消防", "hiddenDangerLedgerr", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_72("安全排查整治", "消防", "housingAndBusinessTogether", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_73("安全排查整治", "消防", "spaceSafetyResponsibility", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_74("安全排查整治", "消防", "doesSpaceApprovalSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_75("安全排查整治", "消防", "spaceOperationSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_76("安全排查整治", "消防", "trainingPlanImplemented", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_77("安全排查整治", "消防", "spaceEmergencyManagement", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_78("安全排查整治", "消防", "spaceManagementProcedure", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_79("安全排查整治", "消防", "installTheSpraySystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_80("安全排查整治", "消防", "elecBicycleParkedCharged", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_81("安全排查整治", "消防", "blockageOfFireEscape", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_82("安全排查整治", "消防", "applyForABusinessLicense", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_83("安全排查整治", "消防", "fireClearance", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_84("安全排查整治", "消防", "fireOfficer", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_85("安全排查整治", "消防", "fireSafetySystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_86("安全排查整治", "消防", "emergencyEvaPlan", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_87("安全排查整治", "消防", "postFireRespon", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_88("安全排查整治", "消防", "personControlSafety", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_89("安全排查整治", "消防", "organizeInspectionWork", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_90("安全排查整治", "消防", "leaseContract", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_91("安全排查整治", "消防", "postAFireSafetyPledge", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_92("安全排查整治", "消防", "putUpFireSafetyPosters", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_93("安全排查整治", "消防", "occupancyArea", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_94("安全排查整治", "消防", "trainingRoomViolation", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_95("安全排查整治", "消防", "perCapitaArea", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_96("安全排查整治", "消防", "fireSeparationOfChildren", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_97("安全排查整治", "消防", "fireKitchenDivider", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_98("安全排查整治", "消防", "kitchenGasAlarm", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_99("安全排查整治", "消防", "rangeHoodCleaning", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_100("安全排查整治", "消防", "foamSandwichColorSteelPlate", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_101("安全排查整治", "消防", "flammableMaterialFinish", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_102("安全排查整治", "消防", "isElecCircuitAging", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_103("安全排查整治", "消防", "socketIsMountedOn", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_104("安全排查整治", "消防", "overloadPower", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_105("安全排查整治", "消防", "externalPowerCable", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_106("安全排查整治", "消防", "electricAppliance", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_107("安全排查整治", "消防", "fireApprovalSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_108("安全排查整治", "消防", "isWeldingOperation", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_109("安全排查整治", "消防", "weldControlMeasure", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_110("安全排查整治", "消防", "safetyExitQuantity", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_111("安全排查整治", "消防", "separateFireExits", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_112("安全排查整治", "消防", "useSlidingDoors", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_113("安全排查整治", "消防", "isAreObstaclesEscape", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_114("安全排查整治", "消防", "safetyDoorOpeningDirection", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_115("安全排查整治", "消防", "areEmergencyRoutes", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_116("安全排查整治", "消防", "equippedEmergFlash", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_117("安全排查整治", "消防", "smokingInPlace", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_118("安全排查整治", "消防", "isFlamExplosive", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_119("安全排查整治", "消防", "organizeFireInspection", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_120("安全排查整治", "消防", "firePatrol", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_121("安全排查整治", "消防", "fireControlRoom", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_122("安全排查整治", "消防", "nightPatrol", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_123("安全排查整治", "消防", "fireFightingDrill", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_124("安全排查整治", "消防", "fireSafetyTraining", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_125("安全排查整治", "消防", "fireFightingEffective", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_126("安全排查整治", "消防", "fireExitsEscapes", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_127("安全排查整治", "消防", "fireEquipeLabels", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_128("安全排查整治", "消防", "independentSmokeAlarm", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_129("安全排查整治", "消防", "fireMaintenance", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_130("安全排查整治", "消防", "specialistPurchasing", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_131("安全排查整治", "消防", "apititudeLegal", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_132("安全排查整治", "消防", "warehousing", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_133("安全排查整治", "消防", "warehouseManagementSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_134("安全排查整治", "消防", "establishHazardMonitoring", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_135("安全排查整治", "消防", "storageRequirement", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_136("安全排查整治", "消防", "safetyEducationSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_137("安全排查整治", "消防", "employeeTrainingRecords", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_138("安全排查整治", "消防", "isPeriodicalAirAndPersonTrain", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_139("安全排查整治", "消防", "emergencyReliefMaterials", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_140("安全排查整治", "消防", "accidentManagementSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_141("安全排查整治", "消防", "beMercilessInAllDirections", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_142("安全排查整治", "消防", "warehouseDistance", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_143("安全排查整治", "消防", "fireProtectionCode", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_144("安全排查整治", "消防", "lightningProtectionDevice", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_145("安全排查整治", "消防", "electricalEquipmentStandard", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_146("安全排查整治", "消防", "electrostaticEquipment", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_147("安全排查整治", "消防", "fireProtectionCertificate", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_148("安全排查整治", "消防", "chemicalContainer", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_149("安全排查整治", "消防", "chemicalStorage", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_150("安全排查整治", "消防", "chemicalStorageArea", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_151("安全排查整治", "消防", "chemicalExcessStorage", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_152("安全排查整治", "消防", "chemicalPermit", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_153("安全排查整治", "消防", "occupationalHazardPrevention", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_154("安全排查整治", "消防", "specialEquipmentInspection", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_155("安全排查整治", "消防", "workplaceWarningSigns", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_156("安全排查整治", "消防", "hazardMonitoring", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_157("安全排查整治", "消防", "safetyDeviceStandard", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_158("安全排查整治", "消防", "equipmentPipeline", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_159("安全排查整治", "消防", "chemicalFactoryCertificate", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_160("安全排查整治", "消防", "noFireworksInStorage", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_161("安全排查整治", "消防", "systemImplementation", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_162("安全排查整治", "消防", "safetyRegulationsAndOperatingProcedures", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_163("安全排查整治", "消防", "safetyEducationAndTrainingProgram", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_164("安全排查整治", "消防", "safetyProductionPlanAndPlan", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_165("安全排查整治", "消防", "mainSafetyManagementSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_166("安全排查整治", "消防", "whetherTheFireHoseIsInGoodCondition", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_167("安全排查整治", "消防", "theSafetyExitSignIsInGoodCondition", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_168("安全排查整治", "消防", "setUpSecurityWindows", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_169("安全排查整治", "消防", "affectEscapeAntiTheftNetwork", "否"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_170("安全排查整治", "消防", "safetyEquipmentIsComplete", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_171("安全排查整治", "消防", "whetherEmployeesHaveSafetyKnowledge", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_172("安全排查整治", "消防", "carryOutEducationAndStudyOnWorkSafety", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_173("安全排查整治", "消防", "thePersonInChargeHoldsThePost", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_174("安全排查整治", "消防", "implementSafetyEducationAndTrainingPrograms", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_175("安全排查整治", "消防", "whetherTheSafetyManagementSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FIRE_PROBLEM_176("安全排查整治", "消防", "whetherTheFireFightingFacilitiesAreDamaged", "否"),
    GUANSHANHU_SECURITY_CHK_GAS_PROBLEM_177("安全排查整治", "消防", "isGasAlarmInstalled", "是"),

    GUANSHANHU_SECURITY_CHK_GAS_PROBLEM_1("安全排查整治", "燃气", "combustibleGasAlarm", "已安装并正常使用"),
    GUANSHANHU_SECURITY_CHK_GAS_PROBLEM_2("安全排查整治", "燃气", "isOverstockedLPGCylinders", "否"),
    GUANSHANHU_SECURITY_CHK_GAS_PROBLEM_3("安全排查整治", "燃气", "gasCylinderCirculation", "正常"),
    GUANSHANHU_SECURITY_CHK_GAS_PROBLEM_4("安全排查整治", "燃气", "connectingHoses", "正常"),
    GUANSHANHU_SECURITY_CHK_GAS_PROBLEM_6("安全排查整治", "燃气", "useGasCylinders", "共享瓶"),
    GUANSHANHU_SECURITY_CHK_GAS_PROBLEM_7("安全排查整治", "燃气", "theHoseMeters", "正常"),

    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_1("安全排查整治", "食品", "cateringRegistrationCertificate", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_2("安全排查整治", "食品", "publicFoodRegistrationCertificate", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_3("安全排查整治", "食品", "wildlifeTrade", "否"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_4("安全排查整治", "食品", "antiFoodWasteAndManagement", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_5("安全排查整治", "食品", "placeInOutNeat", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_6("安全排查整治", "食品", "fivePreventionFacilities", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_7("安全排查整治", "食品", "whetherTablewareIsSterilized", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_8("安全排查整治", "食品", "completeDisinfectionRecord", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_9("安全排查整治", "食品", "isRequirePersonalHygiene", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_10("安全排查整治", "食品", "whetherSystemProcure", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_11("安全排查整治", "食品", "isFoodBusinessLicense", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_12("安全排查整治", "食品", "foodWasteIsStoredInAirtightContainers", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_13("安全排查整治", "食品", "foodAndBeverageFiles", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_14("安全排查整治", "食品", "foodSafetyGuarantee", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_15("安全排查整治", "食品", "postWarrantyInformation", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_16("安全排查整治", "食品", "validityOfFoodPermit", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_17("安全排查整治", "食品", "whetherTheActualOperationIsConsistent", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_18("安全排查整治", "食品", "whetherThereIsAPlaceSuitableForHandlingGoods", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_19("安全排查整治", "食品", "whetherItHasOperatingEquipment", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_20("安全排查整治", "食品", "whetherTheFoodIsWithinItsExpirationDate", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_21("安全排查整治", "食品", "foodSensoryTraits", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_22("安全排查整治", "食品", "foodPackagingLabel", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_23("安全排查整治", "食品", "bulkFoodCompliesWithRegulations", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_24("安全排查整治", "食品", "foodLabellingDealsWithDiseasePrevention", "否"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_25("安全排查整治", "食品", "foodAdvertisingDealsWithDiseasePrevention", "否"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_26("安全排查整治", "食品", "whetherTheImportedFoodIsInCompliance", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_27("安全排查整治", "食品", "storeAndSellFoodAsRequired", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_28("安全排查整治", "食品", "isHaveMedicalCertificate", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_29("安全排查整治", "食品", "healthCertificateAndEmployeeMatching", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_30("安全排查整治", "食品", "thePrincipalIsResponsible", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_31("安全排查整治", "食品", "improveFoodManagement", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_32("安全排查整治", "食品", "dedicatedFoodManager", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_33("安全排查整治", "食品", "establishFoodSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_34("安全排查整治", "食品", "foodWorkRecord", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_35("安全排查整治", "食品", "isFoodBusinessLicense_ry", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_37("安全排查整治", "食品", "noTransferOfLicense", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_38("安全排查整治", "食品", "isDustRodentAvailable", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_39("安全排查整治", "食品", "ventilationFacility", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_40("安全排查整治", "食品", "distanceFromPollutionSource", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_41("安全排查整治", "食品", "healthManagementSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_42("安全排查整治", "食品", "processedFoodForSickPeople", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_43("安全排查整治", "食品", "conductFoodTraining", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_44("安全排查整治", "食品", "noUnidentifiedFood", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_45("安全排查整治", "食品", "determineTheTicketDemandSystem", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_46("安全排查整治", "食品", "shelfLifeOfStockFood", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_47("安全排查整治", "食品", "washAndSterilize", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_48("安全排查整治", "食品", "setUpACutleryCleaner", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_49("安全排查整治", "食品", "disinfectingPondsAndPools", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_50("安全排查整治", "食品", "disinfectionKnowledge", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_51("安全排查整治", "食品", "isDustacilitiesAvailable", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_52("安全排查整治", "食品", "spoilageFreeFood", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_53("安全排查整治", "食品", "rawAndCookedFood", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_54("安全排查整治", "食品", "cookedProcessedFoods", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_55("安全排查整治", "食品", "sampleRetentionEquipment", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_56("安全排查整治", "食品", "heatBeforeServing", "是"),
    GUANSHANHU_SECURITY_CHK_FOOD_PROBLEM_57("安全排查整治", "食品", "foodAdditive", "是"),

    GUANSHANHU_SECURITY_CHK_LABOUR_PROBLEM_1("安全排查整治", "劳资", "payrollStatus", "是"),

    CARE_OLD_SERVICE_1("养老服务站巡查","all","isExtinguisher","是"),
    CARE_OLD_SERVICE_2("养老服务站巡查","all","isHydrantBlocked","无"),
    CARE_OLD_SERVICE_3("养老服务站巡查","all","isExtinguisherExpiredOrDamaged","否"),
    CARE_OLD_SERVICE_4("养老服务站巡查","all","rangeHoodCleanRecord","是"),
    CARE_OLD_SERVICE_5("养老服务站巡查","all","safeTipBadges","是"),
    CARE_OLD_SERVICE_6("养老服务站巡查","all","isHaveMedicalCertificate","是"),
    CARE_OLD_SERVICE_7("养老服务站巡查","all","foodSafetyGuarantee","是"),
    CARE_OLD_SERVICE_8("养老服务站巡查","all","postWarrantyInformation","是"),
    CARE_OLD_SERVICE_9("养老服务站巡查","all","cateringRegistrationCertificate","是"),
    CARE_OLD_SERVICE_10("养老服务站巡查","all","publicFoodRegistrationCertificate","是"),
    CARE_OLD_SERVICE_11("养老服务站巡查","all","wildlifeTrade","否"),
    CARE_OLD_SERVICE_12("养老服务站巡查","all","antiFoodWasteAndManagement","是"),
    CARE_OLD_SERVICE_13("养老服务站巡查","all","placeInOutNeat","是"),
    CARE_OLD_SERVICE_14("养老服务站巡查","all","fivePreventionFacilities","是"),
    CARE_OLD_SERVICE_15("养老服务站巡查","all","whetherTablewareIsSterilized","是"),
    CARE_OLD_SERVICE_16("养老服务站巡查","all","completeDisinfectionRecord","是"),
    CARE_OLD_SERVICE_17("养老服务站巡查","all","whetherSystemProcure","是"),
    CARE_OLD_SERVICE_18("养老服务站巡查","all","foodWasteIsStoredInAirtightContainers","是"),
    CARE_OLD_SERVICE_19("养老服务站巡查","all","foodAndBeverageFiles","是"),
    CARE_OLD_SERVICE_20("养老服务站巡查","all","validityOfFoodPermit","是"),
    CARE_OLD_SERVICE_21("养老服务站巡查","all","whetherTheActualOperationIsConsistent","是"),
    CARE_OLD_SERVICE_22("养老服务站巡查","all","whetherThereIsAPlaceSuitableForHandlingGoods","是"),
    CARE_OLD_SERVICE_23("养老服务站巡查","all","placeInOutNeat","是"),
    CARE_OLD_SERVICE_24("养老服务站巡查","all","whetherItHasOperatingEquipment","是"),
    CARE_OLD_SERVICE_25("养老服务站巡查","all","whetherTheFoodIsWithinItsExpirationDate","是"),
    CARE_OLD_SERVICE_26("养老服务站巡查","all","foodSensoryTraits","是"),
    CARE_OLD_SERVICE_27("养老服务站巡查","all","foodPackagingLabel","是"),
    CARE_OLD_SERVICE_28("养老服务站巡查","all","bulkFoodCompliesWithRegulations","是"),
    CARE_OLD_SERVICE_29("养老服务站巡查","all","foodLabellingDealsWithDiseasePrevention","否"),
    CARE_OLD_SERVICE_30("养老服务站巡查","all","foodAdvertisingDealsWithDiseasePrevention","否"),
    CARE_OLD_SERVICE_31("养老服务站巡查","all","whetherTheImportedFoodIsInCompliance","是"),
    CARE_OLD_SERVICE_32("养老服务站巡查","all","storeAndSellFoodAsRequired","是"),

    SOCIETY_SECURITY_1("社会治安","all","whetherThereIsAnyHiddenDanger","否");

    private final String type;// 类型
    private final String subType;// 子类型
    private final String field;// 主维度
    private final String defalutValue;// 默认值


    DataManageHiddenDangersEnum(String type, String subType, String field, String defalutValue) {
        this.type = type;
        this.subType = subType;
        this.field = field;
        this.defalutValue = defalutValue;
    }

    /**
     * @param type
     * @return
     */
    public static String getSqlCondByType(String type, String subType, String isHiddenDanger) {
        StringBuffer sb = new StringBuffer(" AND (");
        for (DataManageHiddenDangersEnum hiddenDanger : DataManageHiddenDangersEnum.values()) {
            if (hiddenDanger.getType().contains(type) && ("all".equals(subType) || hiddenDanger.getSubType().equals(subType))) {
                if ("0".equals(isHiddenDanger)) {
                    sb.append(" (param_data->>'").append(hiddenDanger.getField()).append("' = '").append(hiddenDanger.getDefalutValue())
                            .append("' OR char_length(param_data->>'").append(hiddenDanger.getField()).append("') IS NULL) AND");
                } else {
                    sb.append(" (param_data->>'").append(hiddenDanger.getField()).append("' != '").append(hiddenDanger.getDefalutValue()).append("') OR");
                }
            }
        }
        String resultSql = "";
        if (ObjectUtil.isNotEmpty(sb) && sb.toString().endsWith("AND")) {
            resultSql = sb.substring(0, sb.length() - 3) + ")";
        } else if (ObjectUtil.isNotEmpty(sb) && sb.toString().endsWith("OR")) {
            resultSql = sb.substring(0, sb.length() - 2) + ")";
        }
        return resultSql;
    }
}
